revDatabaseType

Type

function

Summary

Returns the type of database associated with a connection.

Syntax

revDatabaseType(<databaseID>)

Description

Use the revDatabaseType function to send different queries or perform different operations depending on what kind of database is being used.

You can use the revDatabaseType function to distinguish between different database types. For example, you may need to frame a SQL query differently depending on what type of database you are communicating with.

Important

The revDatabaseType function is part of the Database library. To ensure that the function works in a standalone application, you must include this custom library when you create your standalone. In the Inclusions pane of the Standalone Application Settings window, make sure both the "Database" library checkbox and those of the database drivers you are using are checked.

Parameters

Name	Type	Description
databaseID		The number returned by the revOpenDatabase function when the database was opened.

Examples

if revDatabaseType(1) is not "odbc" then
  checkLicense
end if

if revDatabaseType(the currentDB \
      of group "Display" ) is "Valentina" then
  sendValQuery 
else
  sendGenericQuery
end if

Value

Name	Type	Description
return		The revDatabaseType function returns a string containing up to two items (separated by a comma) Item 1 of the string is one of the following values: "MySQL", "ODBC", "Oracle", "PostgresSQL", "SQLite", "Valentina". Item 2 of the string is empty for all database types except ODBC. If the database type is ODBC then item 2 of the string contains the name of the database system being accessed by the ODBC driver.

Related

function: revDatabaseColumnTypes, revOpenDatabases

glossary: LiveCode custom library, Standalone Application Settings, database, standalone application, return, SQL query

library: Database library

control structure: function

Compatibility and Support

Introduced

LiveCode 1.1.1

OS

mac

windows

linux

ios

android

Platforms

desktop

server

mobile